import pandas as pd
df = pd.read_excel (r'C:\Users\698422\Desktop\Ph.D\Masters Manuscripts\Modeling\Masters Degree Work\Carbonates_microthermometric Data_FINAL FOR BV1.xlsx')
print (df)
Sample Name \
0 BV-83.81 Circle 1 FL1
1 BV-83.81 Circle 2 two very Dark 2-phase FLINC
2 BV-83.81 Circle 3 FL1
3 BV-83.81 Circle 2 FL4
4 BV-83.81 Circle 2 FL5
5 BV-83.81 Circle 2 FL6
6 BV-83.81 Circle 3 FL1
7 BV-106.90 Circle 1 vapour-rich 2-phase FLINC
8 BV-106.90 Circle 1 2-phase FLINC(A)
9 BV-106.90 Circle 1 2-phase FLINC(B)
10 BV-106.90 Circle 1 2-phase FLINC©
11 BV-106.90 Circle 1 2-phase FLINC(D)
12 BV-106.90 Circle 1 2-phase FLINC €
13 BV-106.90 Circle 2 VAPOUR-RICH 2-phase FLINC
14 BV-106.90 Circle 2 2-phase FLINC(A)
15 BV-106.90 Circle 2 2-phase FLINC(B)
16 BV-106.90 Circle 2 2-phase FLINC©
17 BV-106.90 Circle 2 2-phase FLINC(D)
18 BV-352.60 Circle 2 cluster of FLINCs 2-ring FLINC
19 BV-352.60 Circle 2 3-phase FLINC (2-BUBBLES)
20 BV-352.60 Circle 2 Cubic 2-phase FLINC
21 BV-352.60 Circle 2 Rectangular 2-phase FLINC(T...
22 BV-352.60 Spherical Light 2-phase FLINC
23 BV-352.60 Triangle-shaped (cluster)
24 BV-352.60 Circle 4 vapour-rich FLINC
25 BV-417.90(1) P1 FL5 2-phase FLINC
26 BV-417.90(1) P1 FL6 2-phase FLINC
27 BV-417.90(1) P2 FL1 2-phase FLINC(Moving bubble)
28 BV-417.90(1) P3 FL1 2-phase FLINC
29 BV-417.90(2) Circle 5 2-phase cubic FLINC
30 BV-1046.50 (1) Circle 1 FL1
31 BV-1046.50 (1) Circle 1 FL2
32 BV-1046.50 (1) Circle 1 FL3
33 BV-1046.50 (1) Circle 3 Light two-phase FLINC (5)
34 BV-1046.50 (1) Circle 3 Light two-phase FLINC (6)
35 BV-1046.50 (1) Circle 3 Light two-phase FLINC (7)
36 BV-1046.50(1) Circle 3 Dark two-phase FLINC (8)
37 BV-1046.50 (1) Circle 3 Oval light two-phase F...
38 BV-1046.50 (1) Circle 2 Dark,Cubic two-phase F...
39 BV_910_(10)_1_ Circle 2_FL4_Oval 2-phase FLINC
40 BV_910_(10)_1_ Circle 2_FL9_ 2-phase FLINC
41 BV_893.90(2) Circle 1_FL1_V-Rich, 2-Phase FLINC
42 BV_893.90(2) Circle 1_FL2, 2-Phase FLINC
43 BV_893.90(2) Circle 1_FL4, 2-Phase FLINC
44 BV_893.90(2) Circle 1_FL5, 2-Phase FLINC
45 BV_893.90(2) Circle 2_FL1_L-Rich, 2-Phase FLINC
46 BV_893.90(2) Circle 2_FL2, 2-Phase FLINC
47 BV_893.90(2) Circle 2_FL3, 2-Phase FLINC
48 BV_893.90(2) Circle 2_FL4, 2-Phase FLINC
49 BV_893.90(2) Circle 2_FL5, 2-Phase FLINC
TM(melting temperature) TH(homogenization temperature) \
0 -59.3 27.3
1 -56.8 29.8
2 -59.7 29.9
3 -57.8 27.1
4 -58.1 26.8
5 -56.9 29.3
6 -59.7 29.9
7 -56.8 30.8
8 -57.3 24.9
9 -57.6 23.2
10 -56.9 30.1
11 -57.1 24.9
12 -56.9 30.5
13 -56.8 23.8
14 -57.3 24.2
15 -56.9 30.2
16 -57.8 23.4
17 -57.4 23.9
18 -56.8 30.1
19 -57.4 28.9
20 -57.2 30.4
21 -57.2 28.6
22 -57.5 29.5
23 -57.1 30.1
24 -57.1 30.2
25 -57.3 29.7
26 -57.1 28.5
27 -56.9 28.3
28 -56.8 28.8
29 -57.1 30.0
30 -57.1 30.2
31 -56.9 30.8
32 -57.5 29.4
33 -56.9 29.4
34 -57.0 28.6
35 -58.4 29.2
36 -57.1 28.4
37 -56.9 30.2
38 -56.9 30.3
39 -58.4 18.1
40 -59.2 27.5
41 -58.9 28.9
42 -59.6 27.9
43 -58.1 29.1
44 -58.5 29.4
45 -59.6 27.2
46 -57.8 25.3
47 -58.9 28.9
48 -59.2 27.1
49 -58.2 28.2
Form of Homogenization Density of content (FLUIDS PACKAGE) \
0 L+V>L 0.633195
1 L+V>L 0.602200
2 L+V>L 0.598046
3 L+V>L 0.674385
4 L+V>L 0.674385
5 L+V>L 0.620260
6 L+V>L 0.598046
7 L+V>L 0.538068
8 L+V>L 0.712067
9 L+V>L 0.735836
10 L+V>L 0.580644
11 L+V>L 0.712067
12 L+V>L 0.565873
13 L+V>L 0.727830
14 L+V>L 0.722273
15 L+V>L 0.583935
16 L+V>L 0.733269
17 L+V>L 0.726458
18 L+V>L 0.588963
19 L+V>L 0.632440
20 L+V>V 0.364599
21 L+V>L 0.640672
22 L+V>L 0.613940
23 L+V>V 0.349320
24 L+V>L 0.583935
25 L+V>L 0.606143
26 L+V>L 0.643274
27 L+V>L 0.648294
28 L+V>L 0.635260
29 L+V>L 0.593648
30 L+V>L 0.583935
31 L+V>L 0.538068
32 L+V>L 0.616681
33 L+V>L 0.616681
34 L+V>L 0.640640
35 L+V>L 0.623458
36 L+V>L 0.645814
37 L+V>L 0.583935
38 L+V>L 0.578491
39 L+V>L 0.792829
40 L+V>L 0.657690
41 L+V>V 0.309233
42 L+V>L 0.657696
43 L+V>L 0.626549
44 L+V>L 0.616942
45 L+V>L 0.672523
46 L+V>L 0.705922
47 L+V>L 0.632444
48 L+V>L 0.674503
49 L+V>L 0.650720
Density of content Mole conc.(mol/cm3) Molar volume(cm3/mol) \
0 0.670388 0.015236 65.633595
1 0.601867 0.013679 73.105825
2 0.597689 0.013584 73.616861
3 0.674385 0.015327 65.244613
4 0.680156 0.015458 64.691069
5 0.620011 0.014091 70.966474
6 0.597689 0.013584 73.616861
7 0.536871 0.012202 81.956408
8 0.711986 0.016181 61.798983
9 0.735768 0.016722 59.801440
10 0.588545 0.013376 74.760655
11 0.711986 0.016181 61.798983
12 0.565230 0.012846 77.844349
13 0.727758 0.016540 60.459662
14 0.722198 0.016414 60.925102
15 0.583478 0.013261 75.409832
16 0.733140 0.016662 60.015863
17 0.726385 0.016509 60.573908
18 0.588545 0.013376 74.760655
19 0.632237 0.014369 69.594126
20 0.365079 0.008297 120.521757
21 0.640489 0.014557 68.697502
22 0.614940 0.013976 71.551721
23 0.347766 0.007904 126.521690
24 0.586119 0.013321 75.070072
25 0.607715 0.013812 72.402406
26 0.644415 0.014646 68.279018
27 0.649404 0.014759 67.754426
28 0.636461 0.014465 69.132284
29 0.595512 0.013534 73.886025
30 0.583478 0.013261 75.409832
31 0.536871 0.012202 81.956408
32 0.616681 0.014015 71.349746
33 0.618338 0.014053 71.158528
34 0.641830 0.014587 68.553960
35 0.624772 0.014199 70.425739
36 0.646938 0.014703 68.012695
37 0.586119 0.013321 75.070072
38 0.580901 0.013202 75.744346
39 0.793570 0.018036 55.445639
40 0.667415 0.015169 65.925977
41 0.308937 0.007021 142.423750
42 0.658758 0.014972 66.792407
43 0.627829 0.014269 70.082802
44 0.618338 0.014053 71.158528
45 0.673528 0.015307 65.327656
46 0.706840 0.016065 62.248849
47 0.633666 0.014402 69.437158
48 0.675501 0.015352 65.136808
49 0.651816 0.014814 67.503702
Pressure (Mpa) FIA
0 356.692176 Primary
1 294.335667 Primary
2 290.800668 Primary
3 360.597811 Primary
4 366.291824 Primary
5 310.031419 Primary
6 290.800668 Primary
7 242.538438 Primary
8 398.905890 Primary
9 424.669576 Primary
10 283.165402 Primary
11 398.905890 Primary
12 264.315454 Primary
13 415.853779 Secondary
14 409.818125 Secondary
15 278.994286 Secondary
16 421.760767 Secondary
17 414.357402 Secondary
18 283.165402 Primary
19 320.930928 Primary
20 134.527613 Secondary
21 328.438075 Secondary
22 305.587371 Secondary
23 125.659823 Primary
24 281.163082 Primary
25 299.332528 Primary
26 332.052738 Primary
27 336.687790 Secondary
28 324.758120 Secondary
29 288.970029 Secondary
30 278.994286 Primary
31 242.538438 Primary
32 307.107786 Primary
33 308.560067 Primary
34 329.669788 Primary
35 314.243979 Primary
36 334.391177 Primary
37 281.163082 Primary
38 276.888940 Primary
39 492.724648 Secondary
40 353.806875 Secondary
41 106.940290 Secondary
42 345.501539 Secondary
43 316.970329 Secondary
44 308.560067 Secondary
45 359.757480 Primary
46 393.491995 Primary
47 322.222396 Primary
48 361.694053 Primary
49 338.945013 Primary
df.head(52)
| Sample Name | TM(melting temperature) | TH(homogenization temperature) | Form of Homogenization | Density of content (FLUIDS PACKAGE) | Density of content | Mole conc.(mol/cm3) | Molar volume(cm3/mol) | Pressure (Mpa) | FIA | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | BV-83.81 Circle 1 FL1 | -59.3 | 27.3 | L+V>L | 0.633195 | 0.670388 | 0.015236 | 65.633595 | 356.692176 | Primary |
| 1 | BV-83.81 Circle 2 two very Dark 2-phase FLINC | -56.8 | 29.8 | L+V>L | 0.602200 | 0.601867 | 0.013679 | 73.105825 | 294.335667 | Primary |
| 2 | BV-83.81 Circle 3 FL1 | -59.7 | 29.9 | L+V>L | 0.598046 | 0.597689 | 0.013584 | 73.616861 | 290.800668 | Primary |
| 3 | BV-83.81 Circle 2 FL4 | -57.8 | 27.1 | L+V>L | 0.674385 | 0.674385 | 0.015327 | 65.244613 | 360.597811 | Primary |
| 4 | BV-83.81 Circle 2 FL5 | -58.1 | 26.8 | L+V>L | 0.674385 | 0.680156 | 0.015458 | 64.691069 | 366.291824 | Primary |
| 5 | BV-83.81 Circle 2 FL6 | -56.9 | 29.3 | L+V>L | 0.620260 | 0.620011 | 0.014091 | 70.966474 | 310.031419 | Primary |
| 6 | BV-83.81 Circle 3 FL1 | -59.7 | 29.9 | L+V>L | 0.598046 | 0.597689 | 0.013584 | 73.616861 | 290.800668 | Primary |
| 7 | BV-106.90 Circle 1 vapour-rich 2-phase FLINC | -56.8 | 30.8 | L+V>L | 0.538068 | 0.536871 | 0.012202 | 81.956408 | 242.538438 | Primary |
| 8 | BV-106.90 Circle 1 2-phase FLINC(A) | -57.3 | 24.9 | L+V>L | 0.712067 | 0.711986 | 0.016181 | 61.798983 | 398.905890 | Primary |
| 9 | BV-106.90 Circle 1 2-phase FLINC(B) | -57.6 | 23.2 | L+V>L | 0.735836 | 0.735768 | 0.016722 | 59.801440 | 424.669576 | Primary |
| 10 | BV-106.90 Circle 1 2-phase FLINC© | -56.9 | 30.1 | L+V>L | 0.580644 | 0.588545 | 0.013376 | 74.760655 | 283.165402 | Primary |
| 11 | BV-106.90 Circle 1 2-phase FLINC(D) | -57.1 | 24.9 | L+V>L | 0.712067 | 0.711986 | 0.016181 | 61.798983 | 398.905890 | Primary |
| 12 | BV-106.90 Circle 1 2-phase FLINC € | -56.9 | 30.5 | L+V>L | 0.565873 | 0.565230 | 0.012846 | 77.844349 | 264.315454 | Primary |
| 13 | BV-106.90 Circle 2 VAPOUR-RICH 2-phase FLINC | -56.8 | 23.8 | L+V>L | 0.727830 | 0.727758 | 0.016540 | 60.459662 | 415.853779 | Secondary |
| 14 | BV-106.90 Circle 2 2-phase FLINC(A) | -57.3 | 24.2 | L+V>L | 0.722273 | 0.722198 | 0.016414 | 60.925102 | 409.818125 | Secondary |
| 15 | BV-106.90 Circle 2 2-phase FLINC(B) | -56.9 | 30.2 | L+V>L | 0.583935 | 0.583478 | 0.013261 | 75.409832 | 278.994286 | Secondary |
| 16 | BV-106.90 Circle 2 2-phase FLINC© | -57.8 | 23.4 | L+V>L | 0.733269 | 0.733140 | 0.016662 | 60.015863 | 421.760767 | Secondary |
| 17 | BV-106.90 Circle 2 2-phase FLINC(D) | -57.4 | 23.9 | L+V>L | 0.726458 | 0.726385 | 0.016509 | 60.573908 | 414.357402 | Secondary |
| 18 | BV-352.60 Circle 2 cluster of FLINCs 2-ring FLINC | -56.8 | 30.1 | L+V>L | 0.588963 | 0.588545 | 0.013376 | 74.760655 | 283.165402 | Primary |
| 19 | BV-352.60 Circle 2 3-phase FLINC (2-BUBBLES) | -57.4 | 28.9 | L+V>L | 0.632440 | 0.632237 | 0.014369 | 69.594126 | 320.930928 | Primary |
| 20 | BV-352.60 Circle 2 Cubic 2-phase FLINC | -57.2 | 30.4 | L+V>V | 0.364599 | 0.365079 | 0.008297 | 120.521757 | 134.527613 | Secondary |
| 21 | BV-352.60 Circle 2 Rectangular 2-phase FLINC(T... | -57.2 | 28.6 | L+V>L | 0.640672 | 0.640489 | 0.014557 | 68.697502 | 328.438075 | Secondary |
| 22 | BV-352.60 Spherical Light 2-phase FLINC | -57.5 | 29.5 | L+V>L | 0.613940 | 0.614940 | 0.013976 | 71.551721 | 305.587371 | Secondary |
| 23 | BV-352.60 Triangle-shaped (cluster) | -57.1 | 30.1 | L+V>V | 0.349320 | 0.347766 | 0.007904 | 126.521690 | 125.659823 | Primary |
| 24 | BV-352.60 Circle 4 vapour-rich FLINC | -57.1 | 30.2 | L+V>L | 0.583935 | 0.586119 | 0.013321 | 75.070072 | 281.163082 | Primary |
| 25 | BV-417.90(1) P1 FL5 2-phase FLINC | -57.3 | 29.7 | L+V>L | 0.606143 | 0.607715 | 0.013812 | 72.402406 | 299.332528 | Primary |
| 26 | BV-417.90(1) P1 FL6 2-phase FLINC | -57.1 | 28.5 | L+V>L | 0.643274 | 0.644415 | 0.014646 | 68.279018 | 332.052738 | Primary |
| 27 | BV-417.90(1) P2 FL1 2-phase FLINC(Moving bubble) | -56.9 | 28.3 | L+V>L | 0.648294 | 0.649404 | 0.014759 | 67.754426 | 336.687790 | Secondary |
| 28 | BV-417.90(1) P3 FL1 2-phase FLINC | -56.8 | 28.8 | L+V>L | 0.635260 | 0.636461 | 0.014465 | 69.132284 | 324.758120 | Secondary |
| 29 | BV-417.90(2) Circle 5 2-phase cubic FLINC | -57.1 | 30.0 | L+V>L | 0.593648 | 0.595512 | 0.013534 | 73.886025 | 288.970029 | Secondary |
| 30 | BV-1046.50 (1) Circle 1 FL1 | -57.1 | 30.2 | L+V>L | 0.583935 | 0.583478 | 0.013261 | 75.409832 | 278.994286 | Primary |
| 31 | BV-1046.50 (1) Circle 1 FL2 | -56.9 | 30.8 | L+V>L | 0.538068 | 0.536871 | 0.012202 | 81.956408 | 242.538438 | Primary |
| 32 | BV-1046.50 (1) Circle 1 FL3 | -57.5 | 29.4 | L+V>L | 0.616681 | 0.616681 | 0.014015 | 71.349746 | 307.107786 | Primary |
| 33 | BV-1046.50 (1) Circle 3 Light two-phase FLINC (5) | -56.9 | 29.4 | L+V>L | 0.616681 | 0.618338 | 0.014053 | 71.158528 | 308.560067 | Primary |
| 34 | BV-1046.50 (1) Circle 3 Light two-phase FLINC (6) | -57.0 | 28.6 | L+V>L | 0.640640 | 0.641830 | 0.014587 | 68.553960 | 329.669788 | Primary |
| 35 | BV-1046.50 (1) Circle 3 Light two-phase FLINC (7) | -58.4 | 29.2 | L+V>L | 0.623458 | 0.624772 | 0.014199 | 70.425739 | 314.243979 | Primary |
| 36 | BV-1046.50(1) Circle 3 Dark two-phase FLINC (8) | -57.1 | 28.4 | L+V>L | 0.645814 | 0.646938 | 0.014703 | 68.012695 | 334.391177 | Primary |
| 37 | BV-1046.50 (1) Circle 3 Oval light two-phase F... | -56.9 | 30.2 | L+V>L | 0.583935 | 0.586119 | 0.013321 | 75.070072 | 281.163082 | Primary |
| 38 | BV-1046.50 (1) Circle 2 Dark,Cubic two-phase F... | -56.9 | 30.3 | L+V>L | 0.578491 | 0.580901 | 0.013202 | 75.744346 | 276.888940 | Primary |
| 39 | BV_910_(10)_1_ Circle 2_FL4_Oval 2-phase FLINC | -58.4 | 18.1 | L+V>L | 0.792829 | 0.793570 | 0.018036 | 55.445639 | 492.724648 | Secondary |
| 40 | BV_910_(10)_1_ Circle 2_FL9_ 2-phase FLINC | -59.2 | 27.5 | L+V>L | 0.657690 | 0.667415 | 0.015169 | 65.925977 | 353.806875 | Secondary |
| 41 | BV_893.90(2) Circle 1_FL1_V-Rich, 2-Phase FLINC | -58.9 | 28.9 | L+V>V | 0.309233 | 0.308937 | 0.007021 | 142.423750 | 106.940290 | Secondary |
| 42 | BV_893.90(2) Circle 1_FL2, 2-Phase FLINC | -59.6 | 27.9 | L+V>L | 0.657696 | 0.658758 | 0.014972 | 66.792407 | 345.501539 | Secondary |
| 43 | BV_893.90(2) Circle 1_FL4, 2-Phase FLINC | -58.1 | 29.1 | L+V>L | 0.626549 | 0.627829 | 0.014269 | 70.082802 | 316.970329 | Secondary |
| 44 | BV_893.90(2) Circle 1_FL5, 2-Phase FLINC | -58.5 | 29.4 | L+V>L | 0.616942 | 0.618338 | 0.014053 | 71.158528 | 308.560067 | Secondary |
| 45 | BV_893.90(2) Circle 2_FL1_L-Rich, 2-Phase FLINC | -59.6 | 27.2 | L+V>L | 0.672523 | 0.673528 | 0.015307 | 65.327656 | 359.757480 | Primary |
| 46 | BV_893.90(2) Circle 2_FL2, 2-Phase FLINC | -57.8 | 25.3 | L+V>L | 0.705922 | 0.706840 | 0.016065 | 62.248849 | 393.491995 | Primary |
| 47 | BV_893.90(2) Circle 2_FL3, 2-Phase FLINC | -58.9 | 28.9 | L+V>L | 0.632444 | 0.633666 | 0.014402 | 69.437158 | 322.222396 | Primary |
| 48 | BV_893.90(2) Circle 2_FL4, 2-Phase FLINC | -59.2 | 27.1 | L+V>L | 0.674503 | 0.675501 | 0.015352 | 65.136808 | 361.694053 | Primary |
| 49 | BV_893.90(2) Circle 2_FL5, 2-Phase FLINC | -58.2 | 28.2 | L+V>L | 0.650720 | 0.651816 | 0.014814 | 67.503702 | 338.945013 | Primary |
df
pip install plotly_express
Requirement already satisfied: plotly_express in c:\users\698422\anaconda3\lib\site-packages (0.4.1) Requirement already satisfied: pandas>=0.20.0 in c:\users\698422\anaconda3\lib\site-packages (from plotly_express) (1.3.4) Requirement already satisfied: patsy>=0.5 in c:\users\698422\anaconda3\lib\site-packages (from plotly_express) (0.5.2) Requirement already satisfied: plotly>=4.1.0 in c:\users\698422\anaconda3\lib\site-packages (from plotly_express) (5.5.0) Requirement already satisfied: numpy>=1.11 in c:\users\698422\anaconda3\lib\site-packages (from plotly_express) (1.20.3) Requirement already satisfied: scipy>=0.18 in c:\users\698422\anaconda3\lib\site-packages (from plotly_express) (1.7.1) Requirement already satisfied: statsmodels>=0.9.0 in c:\users\698422\anaconda3\lib\site-packages (from plotly_express) (0.12.2) Requirement already satisfied: python-dateutil>=2.7.3 in c:\users\698422\anaconda3\lib\site-packages (from pandas>=0.20.0->plotly_express) (2.8.2) Requirement already satisfied: pytz>=2017.3 in c:\users\698422\anaconda3\lib\site-packages (from pandas>=0.20.0->plotly_express) (2021.3) Requirement already satisfied: six in c:\users\698422\anaconda3\lib\site-packages (from patsy>=0.5->plotly_express) (1.16.0) Requirement already satisfied: tenacity>=6.2.0 in c:\users\698422\anaconda3\lib\site-packages (from plotly>=4.1.0->plotly_express) (8.0.1) Note: you may need to restart the kernel to use updated packages.
import plotly_express as px
px.scatter(df,x="TM(melting temperature)", y="TH(homogenization temperature)")
import plotly_express as px
px.scatter(df_Primary,x="TM(melting temperature)", y="TH(homogenization temperature)")
import plotly_express as px
px.scatter(df_Secondary,x="TM(melting temperature)", y="TH(homogenization temperature)")
df.shape
(50, 10)
df.describe()
| TM(melting temperature) | TH(homogenization temperature) | Density of content (FLUIDS PACKAGE) | Density of content | Mole conc.(mol/cm3) | Molar volume(cm3/mol) | Pressure (Mpa) | |
|---|---|---|---|---|---|---|---|
| count | 50.000000 | 50.000000 | 50.000000 | 50.000000 | 50.000000 | 50.000000 | 50.000000 |
| mean | -57.674000 | 28.144000 | 0.621282 | 0.622927 | 0.014157 | 72.791135 | 319.165619 |
| std | 0.919363 | 2.558472 | 0.089893 | 0.090419 | 0.002055 | 15.805604 | 72.097063 |
| min | -59.700000 | 18.100000 | 0.309233 | 0.308937 | 0.007021 | 55.445639 | 106.940290 |
| 25% | -58.175000 | 27.225000 | 0.590134 | 0.590287 | 0.013416 | 65.404141 | 284.616558 |
| 50% | -57.300000 | 28.900000 | 0.629495 | 0.630033 | 0.014319 | 69.838464 | 318.950629 |
| 75% | -56.900000 | 29.975000 | 0.668816 | 0.672743 | 0.015290 | 74.541997 | 358.991154 |
| max | -56.800000 | 30.800000 | 0.792829 | 0.793570 | 0.018036 | 142.423750 | 492.724648 |
df_Primary = df[ df['FIA'] == 'Primary' ]
df_Primary
| Sample Name | TM(melting temperature) | TH(homogenization temperature) | Form of Homogenization | Density of content (FLUIDS PACKAGE) | Density of content | Mole conc.(mol/cm3) | Molar volume(cm3/mol) | Pressure (Mpa) | FIA | |
|---|---|---|---|---|---|---|---|---|---|---|
| 0 | BV-83.81 Circle 1 FL1 | -59.3 | 27.3 | L+V>L | 0.633195 | 0.670388 | 0.015236 | 65.633595 | 356.692176 | Primary |
| 1 | BV-83.81 Circle 2 two very Dark 2-phase FLINC | -56.8 | 29.8 | L+V>L | 0.602200 | 0.601867 | 0.013679 | 73.105825 | 294.335667 | Primary |
| 2 | BV-83.81 Circle 3 FL1 | -59.7 | 29.9 | L+V>L | 0.598046 | 0.597689 | 0.013584 | 73.616861 | 290.800668 | Primary |
| 3 | BV-83.81 Circle 2 FL4 | -57.8 | 27.1 | L+V>L | 0.674385 | 0.674385 | 0.015327 | 65.244613 | 360.597811 | Primary |
| 4 | BV-83.81 Circle 2 FL5 | -58.1 | 26.8 | L+V>L | 0.674385 | 0.680156 | 0.015458 | 64.691069 | 366.291824 | Primary |
| 5 | BV-83.81 Circle 2 FL6 | -56.9 | 29.3 | L+V>L | 0.620260 | 0.620011 | 0.014091 | 70.966474 | 310.031419 | Primary |
| 6 | BV-83.81 Circle 3 FL1 | -59.7 | 29.9 | L+V>L | 0.598046 | 0.597689 | 0.013584 | 73.616861 | 290.800668 | Primary |
| 7 | BV-106.90 Circle 1 vapour-rich 2-phase FLINC | -56.8 | 30.8 | L+V>L | 0.538068 | 0.536871 | 0.012202 | 81.956408 | 242.538438 | Primary |
| 8 | BV-106.90 Circle 1 2-phase FLINC(A) | -57.3 | 24.9 | L+V>L | 0.712067 | 0.711986 | 0.016181 | 61.798983 | 398.905890 | Primary |
| 9 | BV-106.90 Circle 1 2-phase FLINC(B) | -57.6 | 23.2 | L+V>L | 0.735836 | 0.735768 | 0.016722 | 59.801440 | 424.669576 | Primary |
| 10 | BV-106.90 Circle 1 2-phase FLINC© | -56.9 | 30.1 | L+V>L | 0.580644 | 0.588545 | 0.013376 | 74.760655 | 283.165402 | Primary |
| 11 | BV-106.90 Circle 1 2-phase FLINC(D) | -57.1 | 24.9 | L+V>L | 0.712067 | 0.711986 | 0.016181 | 61.798983 | 398.905890 | Primary |
| 12 | BV-106.90 Circle 1 2-phase FLINC € | -56.9 | 30.5 | L+V>L | 0.565873 | 0.565230 | 0.012846 | 77.844349 | 264.315454 | Primary |
| 18 | BV-352.60 Circle 2 cluster of FLINCs 2-ring FLINC | -56.8 | 30.1 | L+V>L | 0.588963 | 0.588545 | 0.013376 | 74.760655 | 283.165402 | Primary |
| 19 | BV-352.60 Circle 2 3-phase FLINC (2-BUBBLES) | -57.4 | 28.9 | L+V>L | 0.632440 | 0.632237 | 0.014369 | 69.594126 | 320.930928 | Primary |
| 23 | BV-352.60 Triangle-shaped (cluster) | -57.1 | 30.1 | L+V>V | 0.349320 | 0.347766 | 0.007904 | 126.521690 | 125.659823 | Primary |
| 24 | BV-352.60 Circle 4 vapour-rich FLINC | -57.1 | 30.2 | L+V>L | 0.583935 | 0.586119 | 0.013321 | 75.070072 | 281.163082 | Primary |
| 25 | BV-417.90(1) P1 FL5 2-phase FLINC | -57.3 | 29.7 | L+V>L | 0.606143 | 0.607715 | 0.013812 | 72.402406 | 299.332528 | Primary |
| 26 | BV-417.90(1) P1 FL6 2-phase FLINC | -57.1 | 28.5 | L+V>L | 0.643274 | 0.644415 | 0.014646 | 68.279018 | 332.052738 | Primary |
| 30 | BV-1046.50 (1) Circle 1 FL1 | -57.1 | 30.2 | L+V>L | 0.583935 | 0.583478 | 0.013261 | 75.409832 | 278.994286 | Primary |
| 31 | BV-1046.50 (1) Circle 1 FL2 | -56.9 | 30.8 | L+V>L | 0.538068 | 0.536871 | 0.012202 | 81.956408 | 242.538438 | Primary |
| 32 | BV-1046.50 (1) Circle 1 FL3 | -57.5 | 29.4 | L+V>L | 0.616681 | 0.616681 | 0.014015 | 71.349746 | 307.107786 | Primary |
| 33 | BV-1046.50 (1) Circle 3 Light two-phase FLINC (5) | -56.9 | 29.4 | L+V>L | 0.616681 | 0.618338 | 0.014053 | 71.158528 | 308.560067 | Primary |
| 34 | BV-1046.50 (1) Circle 3 Light two-phase FLINC (6) | -57.0 | 28.6 | L+V>L | 0.640640 | 0.641830 | 0.014587 | 68.553960 | 329.669788 | Primary |
| 35 | BV-1046.50 (1) Circle 3 Light two-phase FLINC (7) | -58.4 | 29.2 | L+V>L | 0.623458 | 0.624772 | 0.014199 | 70.425739 | 314.243979 | Primary |
| 36 | BV-1046.50(1) Circle 3 Dark two-phase FLINC (8) | -57.1 | 28.4 | L+V>L | 0.645814 | 0.646938 | 0.014703 | 68.012695 | 334.391177 | Primary |
| 37 | BV-1046.50 (1) Circle 3 Oval light two-phase F... | -56.9 | 30.2 | L+V>L | 0.583935 | 0.586119 | 0.013321 | 75.070072 | 281.163082 | Primary |
| 38 | BV-1046.50 (1) Circle 2 Dark,Cubic two-phase F... | -56.9 | 30.3 | L+V>L | 0.578491 | 0.580901 | 0.013202 | 75.744346 | 276.888940 | Primary |
| 45 | BV_893.90(2) Circle 2_FL1_L-Rich, 2-Phase FLINC | -59.6 | 27.2 | L+V>L | 0.672523 | 0.673528 | 0.015307 | 65.327656 | 359.757480 | Primary |
| 46 | BV_893.90(2) Circle 2_FL2, 2-Phase FLINC | -57.8 | 25.3 | L+V>L | 0.705922 | 0.706840 | 0.016065 | 62.248849 | 393.491995 | Primary |
| 47 | BV_893.90(2) Circle 2_FL3, 2-Phase FLINC | -58.9 | 28.9 | L+V>L | 0.632444 | 0.633666 | 0.014402 | 69.437158 | 322.222396 | Primary |
| 48 | BV_893.90(2) Circle 2_FL4, 2-Phase FLINC | -59.2 | 27.1 | L+V>L | 0.674503 | 0.675501 | 0.015352 | 65.136808 | 361.694053 | Primary |
| 49 | BV_893.90(2) Circle 2_FL5, 2-Phase FLINC | -58.2 | 28.2 | L+V>L | 0.650720 | 0.651816 | 0.014814 | 67.503702 | 338.945013 | Primary |
df_Secondary = df[ df['FIA'] == 'Secondary' ]
df_Secondary
| Sample Name | TM(melting temperature) | TH(homogenization temperature) | Form of Homogenization | Density of content (FLUIDS PACKAGE) | Density of content | Mole conc.(mol/cm3) | Molar volume(cm3/mol) | Pressure (Mpa) | FIA | |
|---|---|---|---|---|---|---|---|---|---|---|
| 13 | BV-106.90 Circle 2 VAPOUR-RICH 2-phase FLINC | -56.8 | 23.8 | L+V>L | 0.727830 | 0.727758 | 0.016540 | 60.459662 | 415.853779 | Secondary |
| 14 | BV-106.90 Circle 2 2-phase FLINC(A) | -57.3 | 24.2 | L+V>L | 0.722273 | 0.722198 | 0.016414 | 60.925102 | 409.818125 | Secondary |
| 15 | BV-106.90 Circle 2 2-phase FLINC(B) | -56.9 | 30.2 | L+V>L | 0.583935 | 0.583478 | 0.013261 | 75.409832 | 278.994286 | Secondary |
| 16 | BV-106.90 Circle 2 2-phase FLINC© | -57.8 | 23.4 | L+V>L | 0.733269 | 0.733140 | 0.016662 | 60.015863 | 421.760767 | Secondary |
| 17 | BV-106.90 Circle 2 2-phase FLINC(D) | -57.4 | 23.9 | L+V>L | 0.726458 | 0.726385 | 0.016509 | 60.573908 | 414.357402 | Secondary |
| 20 | BV-352.60 Circle 2 Cubic 2-phase FLINC | -57.2 | 30.4 | L+V>V | 0.364599 | 0.365079 | 0.008297 | 120.521757 | 134.527613 | Secondary |
| 21 | BV-352.60 Circle 2 Rectangular 2-phase FLINC(T... | -57.2 | 28.6 | L+V>L | 0.640672 | 0.640489 | 0.014557 | 68.697502 | 328.438075 | Secondary |
| 22 | BV-352.60 Spherical Light 2-phase FLINC | -57.5 | 29.5 | L+V>L | 0.613940 | 0.614940 | 0.013976 | 71.551721 | 305.587371 | Secondary |
| 27 | BV-417.90(1) P2 FL1 2-phase FLINC(Moving bubble) | -56.9 | 28.3 | L+V>L | 0.648294 | 0.649404 | 0.014759 | 67.754426 | 336.687790 | Secondary |
| 28 | BV-417.90(1) P3 FL1 2-phase FLINC | -56.8 | 28.8 | L+V>L | 0.635260 | 0.636461 | 0.014465 | 69.132284 | 324.758120 | Secondary |
| 29 | BV-417.90(2) Circle 5 2-phase cubic FLINC | -57.1 | 30.0 | L+V>L | 0.593648 | 0.595512 | 0.013534 | 73.886025 | 288.970029 | Secondary |
| 39 | BV_910_(10)_1_ Circle 2_FL4_Oval 2-phase FLINC | -58.4 | 18.1 | L+V>L | 0.792829 | 0.793570 | 0.018036 | 55.445639 | 492.724648 | Secondary |
| 40 | BV_910_(10)_1_ Circle 2_FL9_ 2-phase FLINC | -59.2 | 27.5 | L+V>L | 0.657690 | 0.667415 | 0.015169 | 65.925977 | 353.806875 | Secondary |
| 41 | BV_893.90(2) Circle 1_FL1_V-Rich, 2-Phase FLINC | -58.9 | 28.9 | L+V>V | 0.309233 | 0.308937 | 0.007021 | 142.423750 | 106.940290 | Secondary |
| 42 | BV_893.90(2) Circle 1_FL2, 2-Phase FLINC | -59.6 | 27.9 | L+V>L | 0.657696 | 0.658758 | 0.014972 | 66.792407 | 345.501539 | Secondary |
| 43 | BV_893.90(2) Circle 1_FL4, 2-Phase FLINC | -58.1 | 29.1 | L+V>L | 0.626549 | 0.627829 | 0.014269 | 70.082802 | 316.970329 | Secondary |
| 44 | BV_893.90(2) Circle 1_FL5, 2-Phase FLINC | -58.5 | 29.4 | L+V>L | 0.616942 | 0.618338 | 0.014053 | 71.158528 | 308.560067 | Secondary |
df_Primary.describe()
| TM(melting temperature) | TH(homogenization temperature) | Density of content (FLUIDS PACKAGE) | Density of content | Mole conc.(mol/cm3) | Molar volume(cm3/mol) | Pressure (Mpa) | |
|---|---|---|---|---|---|---|---|
| count | 33.000000 | 33.000000 | 33.000000 | 33.000000 | 33.000000 | 33.000000 | 33.000000 |
| mean | -57.639394 | 28.642424 | 0.618575 | 0.620505 | 0.014102 | 72.084836 | 314.364360 |
| std | 0.946685 | 1.919640 | 0.068843 | 0.069742 | 0.001585 | 11.226697 | 56.565319 |
| min | -59.700000 | 23.200000 | 0.349320 | 0.347766 | 0.007904 | 59.801440 | 125.659823 |
| 25% | -58.100000 | 27.300000 | 0.583935 | 0.588545 | 0.013376 | 65.633595 | 283.165402 |
| 50% | -57.100000 | 29.300000 | 0.620260 | 0.620011 | 0.014091 | 70.966474 | 310.031419 |
| 75% | -56.900000 | 30.100000 | 0.650720 | 0.670388 | 0.015236 | 74.760655 | 356.692176 |
| max | -56.800000 | 30.800000 | 0.735836 | 0.735768 | 0.016722 | 126.521690 | 424.669576 |
df_Secondary.describe()
| TM(melting temperature) | TH(homogenization temperature) | Density of content (FLUIDS PACKAGE) | Density of content | Mole conc.(mol/cm3) | Molar volume(cm3/mol) | Pressure (Mpa) | |
|---|---|---|---|---|---|---|---|
| count | 17.000000 | 17.000000 | 17.000000 | 17.000000 | 17.000000 | 17.000000 | 17.000000 |
| mean | -57.741176 | 27.176471 | 0.626536 | 0.627629 | 0.014264 | 74.162187 | 328.485712 |
| std | 0.888157 | 3.342067 | 0.123386 | 0.123588 | 0.002809 | 22.582323 | 96.848981 |
| min | -59.600000 | 18.100000 | 0.309233 | 0.308937 | 0.007021 | 55.445639 | 106.940290 |
| 25% | -58.400000 | 24.200000 | 0.613940 | 0.614940 | 0.013976 | 60.925102 | 305.587371 |
| 50% | -57.400000 | 28.600000 | 0.640672 | 0.640489 | 0.014557 | 68.697502 | 328.438075 |
| 75% | -57.100000 | 29.400000 | 0.722273 | 0.722198 | 0.016414 | 71.551721 | 409.818125 |
| max | -56.800000 | 30.400000 | 0.792829 | 0.793570 | 0.018036 | 142.423750 | 492.724648 |
import matplotlib as mpl
import matplotlib.pyplot as plt
import numpy as np
# if using a Jupyter notebook, includue:
%matplotlib inline
# Histogram with bins=30
df.hist(bins=30);
len(df)
50
#define bine edges
bin_edges = [18,20,22,24,26,28,30,32]
# Histogram of 'TH(homogenization temperature)' column
df.hist(column='TH(homogenization temperature)',
bins=bin_edges,
density=False,
histtype='bar',
color='b',
edgecolor='k')
plt.xlabel('TH(homogenization temperature)')
plt.ylabel('Count');
#define bine edges
bin_edges = [-60.0,-59.5,-59.0,-58.5,-58.0,-57.5,-57.0]
# Histogram of 'TM(melting temperature)' column
df.hist(column='TM(melting temperature)',
bins=bin_edges,
histtype='bar',
color='b',
edgecolor='k')
plt.xlabel('TM(melting temperature)')
plt.ylabel('Count');
sns.pairplot(data=df, hue="FIA")
<seaborn.axisgrid.PairGrid at 0x225ca610cd0>
fig,ax = plt.subplots()
sns.scatterplot(data=df, hue='FIA', x='TH(homogenization temperature)', y='TM(melting temperature)')
plt.legend(loc=2)
plt.savefig('scatter.png')
plt.show()
sns.histplot(data=df, x="TH(homogenization temperature)", hue="FIA")
<AxesSubplot:xlabel='TH(homogenization temperature)', ylabel='Count'>
sns.histplot(data=df, x="TH(homogenization temperature)", hue="FIA", multiple="stack")
<AxesSubplot:xlabel='TH(homogenization temperature)', ylabel='Count'>
sns.histplot(data=df, x="TM(melting temperature)", hue="FIA")
<AxesSubplot:xlabel='TM(melting temperature)', ylabel='Count'>
sns.histplot(data=df, x="TM(melting temperature)", hue="FIA", multiple="stack")
<AxesSubplot:xlabel='TM(melting temperature)', ylabel='Count'>
sns.histplot(data=df, x="Molar volume(cm3/mol)", hue="FIA")
<AxesSubplot:xlabel='Molar volume(cm3/mol)', ylabel='Count'>
sns.histplot(data=df, x="Molar volume(cm3/mol)", hue="FIA",multiple="stack")
<AxesSubplot:xlabel='Molar volume(cm3/mol)', ylabel='Count'>
df.dtypes
Sample Name object TM(melting temperature) float64 TH(homogenization temperature) float64 Form of Homogenization object Density of content (FLUIDS PACKAGE) float64 Density of content float64 Mole conc.(mol/cm3) float64 Molar volume(cm3/mol) float64 Pressure (Mpa) float64 FIA object dtype: object
import os
import pandas as pd
Microthermometric_Data_BV_Aqueous = os.path.join('data', 'Carbonates_microthermometric Data_FINAL FOR BV1.xlsx')
results_df = pd.read_excel(r'C:\Users\698422\Desktop\Ph.D\Masters Manuscripts\Modeling\Carbonates_microthermometric Data_FINAL FOR BV1.xlsx')
xdata = results_df['TH(homogenization temperature)']
ydata = results_df['TM(melting temperature)']
from scipy import stats
slope, intercept, r_value, p_value, std_err = stats.linregress(xdata, ydata)
import seaborn as sns
sns.regplot(x = xdata, y = ydata)
<AxesSubplot:xlabel='TH(homogenization temperature)', ylabel='TM(melting temperature)'>
pip install nbconvert
Requirement already satisfied: nbconvert in c:\users\698422\anaconda3\lib\site-packages (6.1.0) Requirement already satisfied: bleach in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (4.0.0) Requirement already satisfied: pandocfilters>=1.4.1 in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (1.4.3) Requirement already satisfied: nbclient<0.6.0,>=0.5.0 in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (0.5.3) Requirement already satisfied: traitlets>=5.0 in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (5.1.0) Requirement already satisfied: mistune<2,>=0.8.1 in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (0.8.4) Requirement already satisfied: defusedxml in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (0.7.1) Requirement already satisfied: nbformat>=4.4 in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (5.1.3) Requirement already satisfied: jinja2>=2.4 in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (2.11.3) Requirement already satisfied: entrypoints>=0.2.2 in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (0.3) Requirement already satisfied: jupyterlab-pygments in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (0.1.2) Requirement already satisfied: testpath in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (0.5.0) Requirement already satisfied: jupyter-core in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (4.8.1) Requirement already satisfied: pygments>=2.4.1 in c:\users\698422\anaconda3\lib\site-packages (from nbconvert) (2.10.0) Requirement already satisfied: MarkupSafe>=0.23 in c:\users\698422\anaconda3\lib\site-packages (from jinja2>=2.4->nbconvert) (1.1.1) Requirement already satisfied: async-generator in c:\users\698422\anaconda3\lib\site-packages (from nbclient<0.6.0,>=0.5.0->nbconvert) (1.10) Requirement already satisfied: jupyter-client>=6.1.5 in c:\users\698422\anaconda3\lib\site-packages (from nbclient<0.6.0,>=0.5.0->nbconvert) (6.1.12) Requirement already satisfied: nest-asyncio in c:\users\698422\anaconda3\lib\site-packages (from nbclient<0.6.0,>=0.5.0->nbconvert) (1.5.1) Requirement already satisfied: pyzmq>=13 in c:\users\698422\anaconda3\lib\site-packages (from jupyter-client>=6.1.5->nbclient<0.6.0,>=0.5.0->nbconvert) (22.2.1) Requirement already satisfied: tornado>=4.1 in c:\users\698422\anaconda3\lib\site-packages (from jupyter-client>=6.1.5->nbclient<0.6.0,>=0.5.0->nbconvert) (6.1) Requirement already satisfied: python-dateutil>=2.1 in c:\users\698422\anaconda3\lib\site-packages (from jupyter-client>=6.1.5->nbclient<0.6.0,>=0.5.0->nbconvert) (2.8.2) Requirement already satisfied: pywin32>=1.0 in c:\users\698422\anaconda3\lib\site-packages (from jupyter-core->nbconvert) (228) Requirement already satisfied: jsonschema!=2.5.0,>=2.4 in c:\users\698422\anaconda3\lib\site-packages (from nbformat>=4.4->nbconvert) (3.2.0) Requirement already satisfied: ipython-genutils in c:\users\698422\anaconda3\lib\site-packages (from nbformat>=4.4->nbconvert) (0.2.0) Requirement already satisfied: six>=1.11.0 in c:\users\698422\anaconda3\lib\site-packages (from jsonschema!=2.5.0,>=2.4->nbformat>=4.4->nbconvert) (1.16.0) Requirement already satisfied: attrs>=17.4.0 in c:\users\698422\anaconda3\lib\site-packages (from jsonschema!=2.5.0,>=2.4->nbformat>=4.4->nbconvert) (21.2.0) Requirement already satisfied: setuptools in c:\users\698422\anaconda3\lib\site-packages (from jsonschema!=2.5.0,>=2.4->nbformat>=4.4->nbconvert) (58.0.4) Requirement already satisfied: pyrsistent>=0.14.0 in c:\users\698422\anaconda3\lib\site-packages (from jsonschema!=2.5.0,>=2.4->nbformat>=4.4->nbconvert) (0.18.0) Requirement already satisfied: packaging in c:\users\698422\anaconda3\lib\site-packages (from bleach->nbconvert) (21.0) Requirement already satisfied: webencodings in c:\users\698422\anaconda3\lib\site-packages (from bleach->nbconvert) (0.5.1) Requirement already satisfied: pyparsing>=2.0.2 in c:\users\698422\anaconda3\lib\site-packages (from packaging->bleach->nbconvert) (3.0.4) Note: you may need to restart the kernel to use updated packages.